SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28678 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28678 [ RunTime:0.002945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (211549,274594,1014099,797836,775588,681984,713683,259090,373220,548235,974154,820754,810984,609021,418350,703842,744018,539967,782300,697082,429668,594984,390203,953163,670310,431068,994548,403889,963594,621679,438752,778639,171700,203551,44226,129252,458485,1045931,389064,217935,804345,381680,770684,750326,149556,101604,534671,973255,1003253,667589,860420,919011,251585,346798,27635,229234,413158,8161,230271,915756) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000650s ]