SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498603 LIMIT 1 [ RunTime:0.000530s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498603 [ RunTime:0.002229s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890918,670455,32271,1018037,427248,1013541,309566,571163,831662,750017,710101,118025,199293,538499,34163,268434,905805,1003646,818591,419980,310686,878104,471744,64754,364817,173102,792814,280347,324022,533903,1020500,937715,533921,756837,525433,313155,319512,318504,220723,259244,106129,891045,618278,611560,68755,227149,35000,440648,622466,143339,856776,286379,564192,818955,181344,534857,162703,195306,825047,1020893) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498603 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498603 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]