SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 264284 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 264284 [ RunTime:0.004812s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (884641,753046,775778,935131,1032100,508809,514591,541287,650278,795765,497435,321406,572840,910463,15560,447898,956664,449100,796694,1031007,1046930,210304,608370,594956,962134,489305,125670,181737,115704,310306,373459,923266,278230,641244,999430,212303,335392,539498,890078,230472,713068,80596,946835,669043,84295,606409,194076,544112,526341,326975,410861,339563,869944,678938,67804,479507,318112,425172,420532,446080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 264284 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 264284 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]