SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024961 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024961 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (766318,250850,227516,480460,1044708,205348,657222,326649,840996,899612,153173,1033424,1037393,231966,899009,205718,1032227,431084,129441,827074,51439,746525,461891,140956,732280,312033,495729,493330,1004411,716886,110253,571512,492601,169854,445978,938747,446395,843774,748152,874566,87253,994166,438130,460929,32920,228229,751535,803973,46531,265335,864863,786051,689962,9928,262872,614068,195790,920122,1026997,89921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001539s ]