SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023775 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023775 [ RunTime:0.001483s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (120218,875764,108991,378052,207790,335818,277035,697498,930475,991820,768441,687834,286979,880383,234081,1013074,573088,22526,580089,441223,379009,71745,548238,811386,55928,706846,787827,780478,163253,577335,217717,476931,622344,1016537,927088,221899,263063,214763,423509,653787,252376,869493,945580,497701,826543,472600,375792,294427,796333,80171,111158,978664,716277,807546,112280,613434,436430,546096,344663,321009) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]