SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 289823 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 289823 [ RunTime:0.002923s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549078,368649,230024,191660,542238,252110,658998,573737,520688,294015,769964,892839,78636,727402,107195,68426,10558,897802,375954,891939,916542,347042,613350,462341,273415,728056,38486,554748,58165,13547,475140,1030555,557947,746615,501077,536973,55195,875783,957412,888586,121602,455180,39049,38149,579943,704745,808690,638210,468082,496189,316252,217765,179696,858863,1032732,181364,146251,151172,739205,677708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001232s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 289823 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 289823 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]