SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001600s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280422 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280422 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (440820,340018,1040233,904605,310293,861812,325227,937879,158427,419888,981380,605449,107680,394393,967015,823316,295866,89337,258411,629939,81682,448393,76642,40096,59562,652047,793457,835204,693336,335354,112097,2297,601095,966578,188003,886084,736257,997561,733994,128856,916602,12808,907513,85550,658906,105231,428537,982643,477624,200959,228437,904545,1004396,889597,691274,157988,552586,420510,996679,185757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001475s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280422 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280422 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]