SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1000626 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1000626 [ RunTime:0.003097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (829110,402346,358301,201041,214575,751511,139636,351107,988213,272331,867550,40791,388829,691463,218822,869230,720212,119463,352839,712960,660086,942045,290239,157200,522984,507527,548453,395206,244426,954328,310011,466052,135901,475531,809690,323872,517392,511736,51979,638371,566961,1011096,399635,878115,625636,563940,876764,88419,193307,443943,265956,344660,688842,868948,1001613,796774,636703,448207,1036583,245297) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1000626 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1000626 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]