SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472417 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472417 [ RunTime:0.003255s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407113,936142,311068,678061,23738,471539,954045,76134,497710,92623,513109,219983,417869,125895,690335,459497,814118,978802,1007787,776834,61940,500094,139377,849867,948830,18961,381187,534087,320210,485253,137053,971507,174652,560879,1011178,842166,946248,663512,837757,912677,4131,810065,433551,643387,443431,524235,877862,482106,387386,943343,1048505,668462,855029,689986,403069,620050,862914,49533,536967,914957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000606s ]