SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53679 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53679 [ RunTime:0.002242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894389,84457,353371,693644,9954,633705,174643,206722,670454,348490,408671,427490,477956,819152,1028539,212642,989170,497071,302728,1045644,826567,209390,976689,673024,564154,99110,544871,680838,664420,283292,489636,7678,648847,170832,720825,941076,719509,388806,621582,873612,275294,591417,647812,102152,564081,597980,951013,977936,284888,270748,428517,167633,719613,580765,865651,542006,296021,664548,781846,901542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53679 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53679 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]