SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001387s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499704 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499704 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314782,3754,291660,269854,240064,776623,556759,907680,202054,995286,974291,210819,413188,1033038,413703,412877,183453,102741,286007,102970,75395,278842,761904,866970,1041835,258766,755816,366942,335604,845334,525501,287174,225162,737725,947917,201136,537344,346538,378281,521350,370629,370302,193783,501383,233532,962679,457661,633146,953181,326898,58102,203440,206453,349332,830976,95557,669925,62444,146020,369283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499704 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499704 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001455s ]