SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 328798 LIMIT 1 [ RunTime:0.001074s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 328798 [ RunTime:0.003111s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45409,775135,734516,1038552,404541,698431,509763,752668,732718,344029,44153,732626,747939,487227,463747,891077,164198,1042699,856206,737188,977227,312506,194791,607574,883939,687706,139165,655621,277569,268927,427668,872890,541432,720101,18814,1020330,262455,58632,854092,774833,1013660,654421,1010115,477275,1017763,759714,902593,411186,135690,1243,267877,389793,574509,198038,145969,290224,66054,972524,36152,799064) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 328798 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 328798 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]