SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524488 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524488 [ RunTime:0.002198s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580421,38055,559667,406854,1027048,90565,143697,954474,276610,457235,532562,285652,852757,776214,485238,340570,835327,309479,221317,365040,786177,529966,190431,882931,721133,708443,361267,845894,1006686,174587,141998,858965,117928,919684,467677,790377,883587,1006648,588422,367179,413108,317420,383852,434825,569811,1014250,851335,28144,881346,852413,985383,977690,147590,775953,240427,431245,194507,707875,672022,404595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007632s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524488 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524488 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001727s ]