SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109551 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109551 [ RunTime:0.001678s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412081,239829,312383,356808,850235,203593,492902,422626,792017,804233,443392,735322,957224,167634,752080,26720,843199,195729,738596,913546,593222,897919,391334,889010,645770,210894,730806,375675,21035,1007465,826999,661290,782359,698942,495682,21305,682997,1027451,418943,1025951,403105,329604,336863,181222,580349,110904,864566,688174,593777,375286,372152,497774,747959,180025,587454,133065,429443,340061,573208,874205) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]