SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501187 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501187 [ RunTime:0.003402s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (34618,263484,1048877,500207,798024,181627,414219,186712,363484,96695,912160,873421,413318,665020,83982,82227,446321,262388,41684,435418,1020672,506732,18796,982746,890668,255573,1020663,1037282,901457,448886,990770,778317,939106,115005,637688,328128,537106,436695,887975,922154,721101,926877,913474,491492,271354,975661,323244,100579,37252,13528,511557,473958,403596,506934,393985,470300,240948,993436,558850,309772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]