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` = 429158 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429158 [ RunTime:0.002583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (754141,889549,972424,948353,789405,104431,50202,889234,433944,303251,116451,744660,168219,19135,619806,258812,55270,860210,884636,317966,801812,119544,417528,679024,234295,170788,732407,1001699,169772,1033412,1010065,864155,735349,582630,171111,234297,13819,125945,888248,154737,554428,181464,120013,725005,265700,646214,489161,1017361,452992,505674,642850,52772,306059,671853,756044,388927,873625,489040,156805,745017) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429158 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429158 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000657s ]