SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400749 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400749 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541437,144171,415376,498792,398804,969266,891506,1019590,308229,919211,250114,547233,609735,46559,259029,402419,47465,425919,800631,500405,338472,398304,261075,784485,235197,9742,1048663,425945,445477,341114,177315,70103,301745,766980,607910,484406,540528,798001,691801,675696,933562,919174,583585,105415,754476,729512,845995,214021,751788,29206,605545,813600,503688,320171,498074,159431,280494,49102,635155,213831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000921s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400749 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400749 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]