SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010897 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010897 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474485,708560,471162,167600,635729,744562,968161,487321,204327,810124,347044,773541,583378,21200,211883,107766,465637,66165,193867,762968,824119,707715,867877,780203,801246,118950,237283,188470,793749,135143,90736,845512,931723,956505,988324,920529,628784,941391,530704,690936,942710,406236,456613,468535,204416,234295,381999,491771,256635,280612,747357,133997,701030,930191,640839,597365,550668,33967,419102,439458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000432s ]