SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005469 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005469 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (368239,477100,993818,690102,512206,1026071,613863,6069,735096,397782,168625,543972,684219,803628,380712,900143,570121,101312,990623,450240,705127,363119,957485,1022564,892459,966083,173085,250131,382273,344229,705307,661331,958968,791332,313206,902447,84756,736510,388475,808690,873209,1005019,538596,615567,1002707,431892,483832,1024481,652615,848791,173673,378487,1023037,972530,387993,28339,131410,147957,104157,620803) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002639s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005469 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005469 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]