SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447176 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447176 [ RunTime:0.005625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38690,652904,1034025,372340,342809,496001,489607,353742,819033,335412,494530,541840,737966,1002509,575827,828883,897531,292635,273660,746738,86620,209108,99645,833941,651220,550260,208399,589743,172591,609601,711666,1014928,857967,54601,736885,439137,199506,102226,838717,259178,337661,1000609,940787,271783,201984,493026,637062,828421,1002031,172330,846746,969459,861072,612438,595408,471700,458126,757052,12090,20264) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]