SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480996 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480996 [ RunTime:0.002500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392513,1015626,780474,122453,733730,506037,827772,572838,773819,23092,449439,55053,681788,904816,948037,154442,706877,131428,52061,3865,107032,959205,767003,195168,815994,302076,878478,1042000,701273,224031,843978,630415,765455,182714,570050,138764,792555,473818,514423,1036157,707940,367167,962286,954079,627884,839423,841227,975102,1041604,897449,804328,802940,374470,180847,44575,48375,771004,365057,742868,342745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001838s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480996 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000412s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480996 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]