SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102813 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102813 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (836469,271683,273160,102578,271151,750170,700920,683888,634442,205652,611543,335705,342165,430800,344538,312677,826510,600251,916119,992775,225969,923509,904531,577545,866742,948377,70788,491138,455392,665646,222866,481153,14046,312734,841777,206082,652311,996380,1025908,213145,653259,847629,851572,515285,348005,603432,388110,343074,644366,765336,720673,387284,845023,811143,576928,629858,681641,703962,321876,307508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]