SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28183 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28183 [ RunTime:0.002733s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (406694,370357,617676,487906,370009,884577,183903,134696,538605,169183,1044919,976174,604638,230890,750269,443526,1035296,233095,911131,937092,402096,111339,331987,225974,170662,808093,832801,673691,896571,929369,47849,873691,423296,446802,671847,432601,307879,399155,579439,569273,492878,422155,194339,588395,320876,668009,226104,801013,560028,766899,844422,890434,788905,847514,638821,717769,578828,223269,779563,796361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000641s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001651s ]