SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48141 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48141 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815891,673419,531634,315450,379808,744500,798827,754655,745684,619510,691508,617535,1037265,664419,184823,858363,804561,974355,812630,402265,135387,876050,480857,654032,579080,118455,710075,330673,11678,226752,617014,364630,790513,194866,814312,754243,1046459,336481,765861,177079,417973,300101,475904,526389,478959,297661,68747,428149,287875,939307,784498,797111,163968,25088,587296,755438,869236,744530,248111,907526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000635s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000715s ]