SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022803 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022803 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358309,319209,891226,152655,976059,783621,321305,872088,1006020,448503,411814,754874,680973,63864,227545,440510,814877,859601,98798,918547,510228,479935,450634,505147,227238,576189,187489,441864,512146,495871,105553,391904,143242,691323,802272,990098,587693,635771,1012326,163593,172066,243813,886568,296477,549847,819514,176867,424924,415936,1043005,465431,418490,326590,914334,53717,865225,459177,49649,467234,472148) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022803 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022803 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]