SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453710 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453710 [ RunTime:0.001499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900266,253859,539032,677198,165879,468428,18793,131615,323080,656141,817196,793390,722810,829132,51586,133846,353188,214853,1016384,135506,555423,241611,353346,903415,505724,199431,1015597,473740,914230,144667,80840,116967,94942,879079,924302,89491,89803,912900,695058,846535,70578,229713,936714,1043874,431039,208186,884594,802866,183430,1012201,780247,724138,617763,917666,50093,453040,321984,860090,245420,871422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000503s ]