SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409917 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409917 [ RunTime:0.002639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1007256,405553,385226,696309,339556,998438,812280,517424,874179,16111,809739,604876,209106,471175,161318,345075,11994,797054,627661,730653,875927,1045034,415291,365958,499651,724883,329567,627827,1035414,229492,374742,155663,13454,197401,870368,607902,940234,144148,505808,311929,81555,357054,585822,336108,933970,697828,854320,971823,136995,386787,70906,833718,951438,315054,546095,378158,85173,490004,578657,484389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]