SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001831s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045534 LIMIT 1 [ RunTime:0.001492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045534 [ RunTime:0.003021s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (688285,943447,701727,474323,1031307,971635,393682,913231,485988,37206,549514,396572,563945,376729,640314,806570,1008603,763706,132478,352647,788265,984260,481203,736123,789080,834843,996726,795834,815557,671975,841091,349214,317003,283128,402792,555225,101081,516250,587816,106513,6840,45335,512601,527081,741958,162369,659291,352827,463562,298398,211453,562591,31143,483186,670750,198182,557535,325581,683303,397432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045534 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045534 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]