SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802522 LIMIT 1 [ RunTime:0.000620s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802522 [ RunTime:0.005280s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825754,916418,1035470,212354,820789,176926,149253,489669,366557,327126,700431,9669,344196,346561,894396,870393,135283,971968,749479,273740,131261,612666,835517,1028466,770429,49411,293441,471460,169848,680349,948999,920893,554799,120490,1018473,359034,568048,271926,869084,582887,694824,638770,344210,609857,644535,513800,146764,570428,1033898,732134,815561,550352,988220,680919,585221,1035002,555312,1044952,554341,547898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802522 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000847s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802522 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000748s ]