SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301117 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301117 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699013,987370,414981,113557,36203,957899,406499,590741,130177,723698,982023,577684,675695,925843,754813,365366,569509,542252,126428,690464,548153,151849,265948,145749,474532,27691,578373,670890,26626,854919,278458,148706,719581,257512,803081,129673,86069,97814,607674,399886,630157,837659,33845,19693,116532,891435,1035437,327759,179643,841916,874754,341375,145705,743394,964770,735789,285258,526378,52125,377357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301117 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301117 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002284s ]