SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 563941 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 563941 [ RunTime:0.002498s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352842,823939,403364,352721,565170,510969,563957,102378,385733,879742,7543,271712,916811,154667,413424,112665,800447,489403,28333,291353,596975,586017,429642,661504,426593,375315,957310,642958,168029,397993,121891,442755,1019198,801859,476449,458762,402348,852085,957181,870371,706742,769959,51614,938658,533259,485341,458898,647696,847551,392888,501008,826681,344685,281833,813512,321120,904663,203011,270971,253975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 563941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 563941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]