SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483517 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483517 [ RunTime:0.001514s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26862,1044756,482237,1004183,628825,979108,585217,767506,257368,639806,1041352,306451,917356,578208,766661,498047,645276,932643,805548,742235,178468,186798,312793,555470,276692,123049,380074,445013,306209,447492,33155,696,979570,281399,123072,722089,938798,457377,519978,807147,6511,594210,981040,670077,789076,152752,230454,692205,540584,907635,105176,863701,473169,751902,710313,1020578,257329,943082,784594,852738) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000725s ]