SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001764s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 195025 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 195025 [ RunTime:0.002481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694328,417165,877387,233352,1028445,689414,941851,234001,312534,818498,778051,261092,803800,712022,863026,35940,408265,1011367,193436,539153,36834,606135,502312,1028459,401515,193180,234249,552983,843170,161765,240406,696500,341551,47344,90861,252965,18546,89128,325366,68936,25750,530977,408105,1048114,241475,543791,510621,577916,837401,557764,443082,56282,135666,106252,1041058,424936,249175,401940,543645,513209) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 195025 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 195025 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000510s ]