SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1044925 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1044925 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115109,519500,463698,559144,1023081,42787,637777,467195,953100,69441,197197,438638,203520,571204,842825,516666,835272,1021544,248301,472854,207328,669647,46761,387749,252066,636299,25906,628665,596637,98603,459870,665271,880643,810418,265353,601150,343588,129070,521125,183117,828491,493107,894027,599649,562798,801649,507109,861057,159748,650481,410459,349123,731400,958764,948831,391150,695775,863819,993275,198432) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1044925 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1044925 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]