SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401345 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401345 [ RunTime:0.002886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376430,610303,78692,934130,579704,156970,122915,850340,128734,183209,363422,319351,223974,5782,738078,75081,312757,988045,320292,909814,90725,431102,266746,208616,149439,357861,447792,1016242,641398,709835,712378,1012303,983906,455162,850424,686200,504268,118876,508570,62680,746590,104633,25649,688012,900834,129640,324304,839786,999837,670106,962269,82743,795786,544904,1030095,322635,89018,592926,817668,556771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401345 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401345 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000674s ]