SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017671 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017671 [ RunTime:0.001948s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (473745,470883,515325,442766,688526,718261,723833,985175,411439,292506,977073,130213,845178,828336,259316,568435,610478,927765,276735,1002320,788166,233133,178054,36625,537440,834071,771276,568317,958852,834595,140458,1042663,245240,412307,552355,140359,646094,587340,949414,326040,788186,489244,524788,868060,356623,357692,960379,911899,636051,338593,554012,71873,508429,783417,100642,577416,786031,237603,350947,291804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017671 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017671 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001222s ]