SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1028169 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1028169 [ RunTime:0.001943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (119771,788711,247120,640381,444466,682972,40863,226733,811548,300173,361015,1025296,433308,754928,989329,804314,241052,939130,277721,1041177,672016,528213,932529,42927,340318,517082,776032,840570,314467,776507,792270,1044467,143008,6285,851619,946565,413260,467138,98304,856130,943759,536880,916817,821884,322020,947904,147675,904468,222998,630367,263636,625552,225583,775415,346087,161554,234930,902507,509778,783989) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002608s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1028169 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1028169 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]