SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 156941 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 156941 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (508871,868341,244248,132922,785681,736987,481619,228004,47677,948064,649287,864384,177528,220992,391028,388675,37425,102560,681829,448758,225868,435800,1007662,698362,313417,286938,320205,733373,305443,448624,442022,1010733,138560,345375,59116,802952,131074,108905,645930,934085,1016092,139759,294039,169561,570050,413656,784777,940907,201006,244831,972923,104960,836121,802623,512057,108208,252746,74161,820639,797095) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 156941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 156941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]