SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001772s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528366 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528366 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480030,151803,761460,999805,909593,1032980,888790,138991,932675,555243,179338,268297,52756,966940,825370,795585,199902,915258,637346,552560,154711,282061,218970,981269,1013908,320187,1001658,318995,35840,334827,941720,1005117,358793,951656,679771,996908,866335,23213,233957,824656,730306,987344,872835,815814,345166,1042038,447665,254516,822056,795553,210567,488184,9970,188426,948707,232632,1029145,253258,562191,203852) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528366 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528366 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000713s ]