SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480203 LIMIT 1 [ RunTime:0.000458s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480203 [ RunTime:0.001749s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (53720,501078,968978,151184,673683,990733,1004498,209209,574181,586494,840579,585327,796192,448032,328729,265732,855990,830319,37250,220369,348683,899260,883267,753144,133859,12414,943175,1041660,978180,476274,363264,993540,321967,137766,703895,310469,431864,605962,77759,386901,973246,819984,207522,958695,434283,953290,452530,1024600,538300,877808,299816,673003,562915,901421,147689,130950,3389,638936,545215,246563) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001006s ]