SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191040 LIMIT 1 [ RunTime:0.002164s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191040 [ RunTime:0.005216s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201415,344403,991302,233578,709357,41441,796039,290129,24994,56979,905852,312843,295082,717957,48174,433832,434483,551732,510669,940472,230248,611144,880650,102917,949127,810484,795712,438507,53568,967700,803859,601392,140021,183391,281799,389132,898642,705353,553465,999231,771381,73234,915469,419558,956814,861146,134361,943796,338985,1003130,365447,77756,366942,897186,498587,591176,903616,520478,100792,83947) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001394s ]