SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541100 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541100 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831230,1033890,3578,1015628,775217,160324,211920,750233,26485,224596,785220,980368,26122,495133,457292,133656,488440,1041306,597047,609862,290188,180423,620018,893218,1015097,976348,562735,642392,898087,153580,415427,122932,516400,822290,315220,234314,185738,217764,9946,15120,221747,297904,259198,113498,200205,531515,94517,446571,281040,729847,395044,821584,675651,938769,86812,972856,853181,523521,29522,863633) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]