SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 29281 LIMIT 1 [ RunTime:0.000916s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 29281 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (479019,41047,890427,1030130,852047,162903,909592,179625,586275,121761,138023,899609,735055,684394,191469,304105,1010843,784052,509413,224994,117441,44884,619158,149162,110608,132990,304989,809869,682966,477392,761202,320618,57075,13313,674086,843142,436483,255659,313590,394884,60497,416744,370445,73474,125671,68488,454982,350829,878466,728364,58825,68327,131344,359578,892016,980736,754317,18687,796224,287227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 29281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 29281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000653s ]