SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1016504 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1016504 [ RunTime:0.002447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155367,741918,18207,270536,986700,214095,584503,762177,168904,293980,219824,821494,675047,1033147,209722,511404,737730,908544,192545,347742,217,332145,701816,860346,514901,41597,744762,593295,101285,881658,860110,722356,25286,262101,804412,131969,193360,763131,282493,201009,1011842,485434,222497,938890,147088,4195,642141,32347,846538,680619,952322,400750,742761,867980,603614,593650,382931,114706,436970,788949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1016504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1016504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]