SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419461 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419461 [ RunTime:0.001846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572612,384990,622580,496182,52725,501374,295702,450483,356161,823838,900828,100183,398961,837242,55719,814147,173519,241050,1014851,855430,245517,630663,1001028,332633,385207,476025,973264,677584,646434,695151,40445,1006115,190248,146435,1018424,146800,11807,678226,44687,238282,619896,300171,672953,423069,247402,811856,1017999,159117,114720,641498,624198,960312,959041,1027781,433822,116673,80793,53874,756403,419794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001719s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419461 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419461 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]