SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527771 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527771 [ RunTime:0.001912s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (961223,1012377,490466,778797,882999,11332,303117,310121,886512,762999,571686,680780,255777,783278,721535,306181,904301,398738,466930,406280,190098,306310,770096,379952,574027,913762,329002,727101,481508,953039,327297,384608,315472,133637,652877,497877,650975,983806,101668,817292,574905,544697,503889,100506,393762,908721,334126,334060,215597,722460,359925,440199,644236,930317,624663,440817,458310,501108,256072,88706) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.013669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000488s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001315s ]