SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529534 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529534 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (106972,1019356,432191,881544,753140,687664,299495,850643,982897,997528,431436,191423,727163,432530,651528,683976,478321,7817,699870,355040,336418,485747,308458,701632,601459,118262,498147,637719,944375,1034917,282786,115859,897888,815656,106673,137121,704579,665445,981159,474399,353399,34693,578004,585370,590907,327369,197489,246319,187630,765846,999772,558081,944326,434370,586986,688505,106449,639356,447459,704848) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000684s ]