SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 927048 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 927048 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (522040,1012598,829326,1042163,145113,96883,360648,528843,929261,155240,175945,662227,784000,616370,1034302,646621,921621,1041517,866823,913217,277034,351746,463700,588294,106487,352299,579041,840711,35880,1022995,997661,980421,908248,474685,1042317,524105,191749,545990,78064,716670,205829,974523,514171,283568,148489,231826,103859,733243,139091,205842,606667,81619,129179,707410,123176,343168,104379,912538,70018,700049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 927048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 927048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]