SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039791 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039791 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432398,736353,703444,547220,800666,467125,777571,909773,7464,193174,910466,705208,791350,74784,334212,712247,181735,646710,415174,916915,917861,197151,629942,95970,728027,534021,778861,452991,760310,868839,697190,4521,37675,433252,820317,147580,77221,244257,628711,791361,252584,387875,460965,536115,709515,72959,608149,99334,765084,642812,208205,678372,5848,578052,41351,196021,772693,524264,1023329,411760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039791 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039791 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001640s ]