SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405504 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405504 [ RunTime:0.003985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945843,166765,393639,972453,948120,622597,837418,754043,874069,173321,616954,361833,944939,871294,798962,326273,300670,17192,453743,553312,1041013,524863,328205,273269,292269,389699,446884,816718,396104,907656,702274,104783,1038725,368328,339876,969647,77162,550191,652145,351531,176938,799838,248709,949382,753284,252599,720975,862158,572577,196627,933263,902532,745731,738459,976724,850449,850027,833634,773913,685154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002729s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]