SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1036517 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1036517 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1001391,176259,144814,603062,790460,800039,836758,684871,1041695,534676,360081,816234,846480,81412,272417,291883,515550,369380,225846,322065,63599,567415,787642,16000,839914,1718,435318,953276,31383,598081,123176,641636,415989,1043148,116407,122487,1013388,714333,826303,16773,928685,127871,806759,803376,192583,76653,596245,9103,573996,376875,988874,179114,9718,572798,353143,219309,201075,248782,139691,200342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1036517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1036517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]