SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 331110 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 331110 [ RunTime:0.003065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734538,808412,484647,1042028,368903,601731,866142,559600,143256,969439,538112,766162,366325,1000228,290304,97187,16334,962621,772362,191943,175312,832953,373017,654967,379683,451464,198692,767047,954693,383941,676668,787496,571071,496806,767613,574231,75110,913128,889532,10954,662128,820714,1041461,834289,601018,866208,149820,909751,874110,806114,577879,470520,648473,863269,826683,651093,1042021,1034274,951916,285424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 331110 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 331110 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]