SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538029 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538029 [ RunTime:0.001559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (227151,258962,739012,462762,629065,292512,979598,700597,1026131,460595,111419,5133,389914,34214,842404,90720,932352,184722,896745,347657,155284,327670,733586,902309,719013,240627,431591,203201,856279,1047176,248062,969960,559896,886228,565608,968636,785897,291242,469950,671082,337899,264357,430058,789642,48293,169952,306531,666865,328544,478267,928362,106509,435911,716,973254,108257,658276,246998,460949,449404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000919s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]