SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001597s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021164 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021164 [ RunTime:0.002602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482175,558786,340543,9903,696931,923615,1033704,38306,438022,450746,1019360,301673,5323,63677,114828,964620,894634,555445,180648,916453,956448,250077,209487,102215,1038939,818775,499234,337391,502906,95889,639629,126142,99688,673634,854139,879063,764694,937174,202136,333496,984410,495633,693681,716950,738204,1036381,448664,603534,805233,627412,418100,355423,1044562,424945,774984,529390,504282,839720,672808,541906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021164 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021164 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001050s ]