SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003486s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475569 LIMIT 1 [ RunTime:0.001066s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475569 [ RunTime:0.005060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001832,80501,703152,25341,220072,998992,825179,981015,439935,309612,1031908,840826,229505,317427,49038,72666,574597,898795,188465,958678,197970,323849,411001,873288,1045182,360191,621263,152040,287416,964729,152034,901530,662935,414661,169818,502010,724981,851268,954682,199913,352166,167753,107791,288691,825504,375692,117063,164224,1037277,748146,139995,96308,803436,227692,462373,954864,842180,863350,873334,74283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006177s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475569 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002688s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475569 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]