SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002915s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 952690 LIMIT 1 [ RunTime:0.000501s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 952690 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123375,842443,1019209,798679,457471,782890,567122,522999,255103,823156,768463,1033130,53744,268212,32420,66899,591165,879110,176205,593934,558144,30224,1035851,532812,759979,453480,387506,210136,411539,897341,1011355,986498,545489,1038154,130864,544489,20423,632204,836642,149984,974185,585034,1047342,7953,1033427,434408,1008403,606729,481256,159775,1026769,1011761,335562,990,70705,724080,477577,908186,1024682,85729) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 952690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 952690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]