SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 811698 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 811698 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (968916,866446,104072,416889,372863,961861,862369,591203,796008,1023824,328234,112367,1045182,498754,105678,636477,870726,129205,340544,807101,427355,552864,69102,1005376,556464,90696,118260,599425,1025692,1022899,918276,302984,33071,756305,841093,881690,330413,559256,253106,186379,457480,24762,787413,281697,247363,982308,327755,385073,315977,903873,16119,223809,51125,381444,407783,36104,211418,766784,615553,164599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 811698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 811698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]