SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001621s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 574281 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 574281 [ RunTime:0.001609s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (906347,1021575,509822,93117,505774,1007387,1005395,134124,694853,817100,989137,225557,316647,868806,732811,612024,194513,817198,73076,518200,645234,158162,437866,985281,845561,393850,510480,284222,635729,292550,108620,798035,121474,981303,161276,264310,252991,682164,376421,277733,235198,886602,93880,831943,320044,206189,501813,81696,381272,202322,323378,106905,109052,390147,537956,432342,205661,644205,2797,74811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 574281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 574281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]