SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 460829 LIMIT 1 [ RunTime:0.000570s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 460829 [ RunTime:0.002158s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013833,266903,892818,146391,311383,510071,765187,1005413,364686,606092,224960,776523,692277,631800,358981,584365,843802,66112,258630,746798,497601,422657,481644,126072,207233,69103,393268,471822,97491,328921,693602,250361,194898,529320,791549,21904,881172,141169,10016,619093,701690,883234,243868,413292,568978,622296,365707,860396,884412,40434,375714,962781,385612,751451,994971,1036714,802602,976311,699876,247887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 460829 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 460829 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]