SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001661s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014854 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014854 [ RunTime:0.003869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323885,281114,108611,704678,248292,155348,270652,120719,403371,148820,148802,555775,923491,978771,746706,982717,750428,242794,570003,43977,366983,664528,445038,738657,288508,556019,877921,522445,65023,413371,826868,790396,753077,107544,45042,981717,145705,75544,116390,390515,679920,293730,803119,9263,147544,227338,140235,252888,629152,229449,24895,798782,839898,195828,913008,964425,861946,349487,106568,400223) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001043s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]