SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 462946 LIMIT 1 [ RunTime:0.001776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 462946 [ RunTime:0.004247s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883661,641043,783260,759786,1005812,1006773,223361,757966,399895,974199,525457,1046782,837472,223365,444629,386399,190339,5217,715075,400970,611333,236251,295047,410077,580270,827225,221042,706357,1047857,969937,504671,451285,1043809,45413,47832,863998,942855,18070,648903,1027938,924154,155954,556361,846493,221414,402906,996411,434317,206499,1034197,461053,81291,55965,518049,375909,1023437,348769,764027,732121,957354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 462946 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 462946 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]