SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508400 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508400 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (916503,902769,718324,484104,387579,148388,148329,605496,39232,105108,485964,1007500,252866,466131,25481,369834,380604,951481,257568,795652,48280,994777,893991,628631,110371,333184,352530,719250,830095,168551,652272,6707,293140,522197,929636,74839,698889,163012,503000,900391,391165,721033,596651,933412,820499,461307,973745,875159,380704,499606,251373,87996,638611,111229,490036,765505,124448,581306,624760,301861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508400 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000699s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508400 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]