SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401145 LIMIT 1 [ RunTime:0.003577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401145 [ RunTime:0.001055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200558,456180,158771,379123,838664,621247,172461,414393,189754,537920,56468,813196,487577,952398,784372,1009062,497606,1026585,239120,229025,237385,346809,83781,652666,352278,570081,700865,682236,82834,436880,732781,982111,894597,263637,432204,833421,344484,766912,905172,761648,737396,915291,795566,205890,239502,618440,909055,697794,987807,455017,700965,58709,533642,718328,325140,992905,937024,727447,22751,850859) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001868s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401145 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401145 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]