SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544914 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544914 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (222229,644682,201426,905763,359571,889483,551655,919969,551409,129789,770461,795208,898313,378276,484437,254946,256403,722503,362167,48633,365632,829376,727713,894825,745194,663709,363383,579006,407245,234822,221295,190956,240879,167624,366343,235350,506116,601786,495741,153528,990113,278789,253010,551674,765695,576838,30343,336786,465993,46098,347722,964851,376786,825153,902225,973363,356547,331146,523451,974480) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544914 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544914 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]