SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5203 LIMIT 1 [ RunTime:0.000409s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5203 [ RunTime:0.002993s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285893,439866,660014,301457,240430,749046,175607,92864,4754,512947,1036777,1023335,78292,1000505,694471,248697,338102,457267,700615,397469,247813,891293,912628,879511,763984,959564,799343,623690,860211,816029,995991,396386,902036,575365,673501,411203,380444,668656,148782,982393,134654,173264,23873,557052,882110,520692,728872,952067,335193,340276,917211,308165,555391,252410,615102,44081,1029887,749093,506868,682427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]